USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_PERGUNTA_ALTERAR')
	DROP PROCEDURE P_PERGUNTA_ALTERAR
GO
CREATE PROCEDURE P_PERGUNTA_ALTERAR(
	@IDPERGUNTA		INTEGER,
	@OBRIGATORIO	CHAR(1),
	@PADRAO			CHAR(1),
	@USUARIO		VARCHAR(100))
AS BEGIN
	UPDATE
		PERGUNTA
	SET
		OBRIGATORIO = @OBRIGATORIO,
		PADRAO = @PADRAO,
		USUARIOALTERACAO = @USUARIO,
		DTHRALTERACAO = GETDATE()
	WHERE
		IDPERGUNTA = @IDPERGUNTA
END